Release 10.1A: OpenEdge Data Management:
SQL Reference

LAST_DAY

Returns the date corresponding to the last day of the month containing the argument date.

Syntax

LAST_DAY ( date_expression )

Example

This example illustrates the LAST_DAY function:

SELECT * FROM orders WHERE LAST_DAY (order_date) + 1 = '08/01/2003' ;

Notes

The argument to the function must be of type DATE.
The result is of type DATE.
If the argument expression evaluates to NULL, the result is NULL.

Compatibility

Progress extension